﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsCertificate" targetNamespace="http://tempuri.org/dsCertificate.xsd" xmlns:mstns="http://tempuri.org/dsCertificate.xsd" xmlns="http://tempuri.org/dsCertificate.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString3" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString3 (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString3" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCertificateCrewTableAdapter" GeneratorDataComponentClassName="tblCertificateCrewTableAdapter" Name="tblCertificateCrew" UserDataComponentName="tblCertificateCrewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCertificateCrew" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblCertificateCrew] WHERE (([nCertificateCrew] = @Original_nCertificateCrew) AND ((@IsNull_nCertificationId = 1 AND [nCertificationId] IS NULL) OR ([nCertificationId] = @Original_nCertificationId)) AND ((@IsNull_nCrewid = 1 AND [nCrewid] IS NULL) OR ([nCrewid] = @Original_nCrewid)) AND ((@IsNull_cIssuedBy = 1 AND [cIssuedBy] IS NULL) OR ([cIssuedBy] = @Original_cIssuedBy)) AND ((@IsNull_dDateOfIssued = 1 AND [dDateOfIssued] IS NULL) OR ([dDateOfIssued] = @Original_dDateOfIssued)) AND ((@IsNull_dDateOfExpire = 1 AND [dDateOfExpire] IS NULL) OR ([dDateOfExpire] = @Original_dDateOfExpire)) AND ((@IsNull_nFileName = 1 AND [nFileName] IS NULL) OR ([nFileName] = @Original_nFileName)) AND ((@IsNull_cExt = 1 AND [cExt] IS NULL) OR ([cExt] = @Original_cExt)) AND ((@IsNull_IsUnlimited = 1 AND [IsUnlimited] IS NULL) OR ([IsUnlimited] = @Original_IsUnlimited)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertificateCrew" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificateCrew" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cIssuedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cIssuedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfIssued" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfIssued" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfExpire" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfExpire" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfExpire" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfExpire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nFileName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFileName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nFileName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nFileName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cExt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cExt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_cExt" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cExt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsUnlimited" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsUnlimited" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsUnlimited" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsUnlimited" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblCertificateCrew] ([nCertificationId], [nCrewid], [cIssuedBy], [cNumber], [dDateOfIssued], [dDateOfExpire], [nFileName], [bScanDoc], [cExt], [IsUnlimited]) VALUES (@nCertificationId, @nCrewid, @cIssuedBy, @cNumber, @dDateOfIssued, @dDateOfExpire, @nFileName, @bScanDoc, @cExt, @IsUnlimited);
SELECT nCertificateCrew, nCertificationId, nCrewid, cIssuedBy, cNumber, dDateOfIssued, dDateOfExpire, nFileName, bScanDoc, cExt, IsUnlimited FROM tblCertificateCrew WHERE (nCertificateCrew = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cIssuedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfIssued" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfExpire" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfExpire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nFileName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nFileName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bScanDoc" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="bScanDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cExt" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cExt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsUnlimited" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsUnlimited" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nCertificateCrew, nCertificationId, nCrewid, cIssuedBy, cNumber, dDateOfIssued, dDateOfExpire, nFileName, bScanDoc, cExt, IsUnlimited
FROM            tblCertificateCrew</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblCertificateCrew] SET [nCertificationId] = @nCertificationId, [nCrewid] = @nCrewid, [cIssuedBy] = @cIssuedBy, [cNumber] = @cNumber, [dDateOfIssued] = @dDateOfIssued, [dDateOfExpire] = @dDateOfExpire, [nFileName] = @nFileName, [bScanDoc] = @bScanDoc, [cExt] = @cExt, [IsUnlimited] = @IsUnlimited WHERE (([nCertificateCrew] = @Original_nCertificateCrew) AND ((@IsNull_nCertificationId = 1 AND [nCertificationId] IS NULL) OR ([nCertificationId] = @Original_nCertificationId)) AND ((@IsNull_nCrewid = 1 AND [nCrewid] IS NULL) OR ([nCrewid] = @Original_nCrewid)) AND ((@IsNull_cIssuedBy = 1 AND [cIssuedBy] IS NULL) OR ([cIssuedBy] = @Original_cIssuedBy)) AND ((@IsNull_dDateOfIssued = 1 AND [dDateOfIssued] IS NULL) OR ([dDateOfIssued] = @Original_dDateOfIssued)) AND ((@IsNull_dDateOfExpire = 1 AND [dDateOfExpire] IS NULL) OR ([dDateOfExpire] = @Original_dDateOfExpire)) AND ((@IsNull_nFileName = 1 AND [nFileName] IS NULL) OR ([nFileName] = @Original_nFileName)) AND ((@IsNull_cExt = 1 AND [cExt] IS NULL) OR ([cExt] = @Original_cExt)) AND ((@IsNull_IsUnlimited = 1 AND [IsUnlimited] IS NULL) OR ([IsUnlimited] = @Original_IsUnlimited)));
SELECT nCertificateCrew, nCertificationId, nCrewid, cIssuedBy, cNumber, dDateOfIssued, dDateOfExpire, nFileName, bScanDoc, cExt, IsUnlimited FROM tblCertificateCrew WHERE (nCertificateCrew = @nCertificateCrew)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cIssuedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfIssued" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfExpire" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfExpire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nFileName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nFileName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bScanDoc" Precision="0" ProviderType="VarBinary" Scale="0" Size="0" SourceColumn="bScanDoc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@cExt" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cExt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsUnlimited" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsUnlimited" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertificateCrew" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificateCrew" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewid" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewid" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewid" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cIssuedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cIssuedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfIssued" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfIssued" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfExpire" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfExpire" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfExpire" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfExpire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nFileName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFileName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nFileName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nFileName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cExt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cExt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_cExt" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="cExt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IsUnlimited" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IsUnlimited" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_IsUnlimited" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="IsUnlimited" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nCertificateCrew" ColumnName="nCertificateCrew" DataSourceName="CrewManagment.dbo.tblCertificateCrew" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nCertificateCrew" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nCertificateCrew" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nCertificateCrew" DataSetColumn="nCertificateCrew" />
              <Mapping SourceColumn="nCertificationId" DataSetColumn="nCertificationId" />
              <Mapping SourceColumn="nCrewid" DataSetColumn="nCrewid" />
              <Mapping SourceColumn="cIssuedBy" DataSetColumn="cIssuedBy" />
              <Mapping SourceColumn="cNumber" DataSetColumn="cNumber" />
              <Mapping SourceColumn="dDateOfIssued" DataSetColumn="dDateOfIssued" />
              <Mapping SourceColumn="dDateOfExpire" DataSetColumn="dDateOfExpire" />
              <Mapping SourceColumn="nFileName" DataSetColumn="nFileName" />
              <Mapping SourceColumn="bScanDoc" DataSetColumn="bScanDoc" />
              <Mapping SourceColumn="cExt" DataSetColumn="cExt" />
              <Mapping SourceColumn="IsUnlimited" DataSetColumn="IsUnlimited" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCertificationRequireTableAdapter" GeneratorDataComponentClassName="tblCertificationRequireTableAdapter" Name="tblCertificationRequire" UserDataComponentName="tblCertificationRequireTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCertificationRequire" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblCertificationRequire] WHERE (([nCertifcationRequireId] = @Original_nCertifcationRequireId) AND ((@IsNull_nCertificationId = 1 AND [nCertificationId] IS NULL) OR ([nCertificationId] = @Original_nCertificationId)) AND ((@IsNull_nRankId = 1 AND [nRankId] IS NULL) OR ([nRankId] = @Original_nRankId)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertifcationRequireId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertifcationRequireId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblCertificationRequire] ([nCertificationId], [nRankId], [cDescription]) VALUES (@nCertificationId, @nRankId, @cDescription);
SELECT nCertifcationRequireId, nCertificationId, nRankId, cDescription FROM tblCertificationRequire WHERE (nCertifcationRequireId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nCertifcationRequireId, nCertificationId, nRankId, cDescription FROM dbo.tblCertificationRequire</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblCertificationRequire] SET [nCertificationId] = @nCertificationId, [nRankId] = @nRankId, [cDescription] = @cDescription WHERE (([nCertifcationRequireId] = @Original_nCertifcationRequireId) AND ((@IsNull_nCertificationId = 1 AND [nCertificationId] IS NULL) OR ([nCertificationId] = @Original_nCertificationId)) AND ((@IsNull_nRankId = 1 AND [nRankId] IS NULL) OR ([nRankId] = @Original_nRankId)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)));
SELECT nCertifcationRequireId, nCertificationId, nRankId, cDescription FROM tblCertificationRequire WHERE (nCertifcationRequireId = @nCertifcationRequireId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertifcationRequireId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertifcationRequireId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nCertifcationRequireId" ColumnName="nCertifcationRequireId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nCertifcationRequireId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nCertifcationRequireId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nCertifcationRequireId" DataSetColumn="nCertifcationRequireId" />
              <Mapping SourceColumn="nCertificationId" DataSetColumn="nCertificationId" />
              <Mapping SourceColumn="nRankId" DataSetColumn="nRankId" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCertificationRequire" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillBy_RankId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy_RankId" GeneratorSourceName="FillBy_RankId" GetMethodModifier="Public" GetMethodName="GetDataBy_RankId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy_RankId" UserSourceName="FillBy_RankId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT nCertifcationRequireId, nCertificationId, nRankId, cDescription FROM dbo.tblCertificationRequire
where nRankId = @nRankId</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="nRankId" ColumnName="nRankId" DataSourceName="CrewManagment.dbo.tblCertificationRequire" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nRankId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nRankId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCertificationTableAdapter" GeneratorDataComponentClassName="tblCertificationTableAdapter" Name="tblCertification" UserDataComponentName="tblCertificationTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCertification" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblCertification] WHERE (([nCertificationId] = @Original_nCertificationId) AND ((@IsNull_cCertificationName = 1 AND [cCertificationName] IS NULL) OR ([cCertificationName] = @Original_cCertificationName)) AND ((@IsNull_cCertificationDescription = 1 AND [cCertificationDescription] IS NULL) OR ([cCertificationDescription] = @Original_cCertificationDescription)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCertificationName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCertificationName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCertificationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCertificationName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCertificationDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCertificationDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCertificationDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCertificationDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblCertification] ([cCertificationName], [cCertificationDescription]) VALUES (@cCertificationName, @cCertificationDescription);
SELECT nCertificationId, cCertificationName, cCertificationDescription FROM tblCertification WHERE (nCertificationId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCertificationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCertificationName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCertificationDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCertificationDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nCertificationId, cCertificationName, cCertificationDescription FROM dbo.tblCertification</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblCertification] SET [cCertificationName] = @cCertificationName, [cCertificationDescription] = @cCertificationDescription WHERE (([nCertificationId] = @Original_nCertificationId) AND ((@IsNull_cCertificationName = 1 AND [cCertificationName] IS NULL) OR ([cCertificationName] = @Original_cCertificationName)) AND ((@IsNull_cCertificationDescription = 1 AND [cCertificationDescription] IS NULL) OR ([cCertificationDescription] = @Original_cCertificationDescription)));
SELECT nCertificationId, cCertificationName, cCertificationDescription FROM tblCertification WHERE (nCertificationId = @nCertificationId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCertificationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCertificationName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cCertificationDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCertificationDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCertificationName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCertificationName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCertificationName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCertificationName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCertificationDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCertificationDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cCertificationDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cCertificationDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nCertificationId" ColumnName="nCertificationId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nCertificationId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nCertificationId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nCertificationId" DataSetColumn="nCertificationId" />
              <Mapping SourceColumn="cCertificationName" DataSetColumn="cCertificationName" />
              <Mapping SourceColumn="cCertificationDescription" DataSetColumn="cCertificationDescription" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCertification" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByRankId" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByRankId" GeneratorSourceName="FillByRankId" GetMethodModifier="Public" GetMethodName="GetDataByRankId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByRankId" UserSourceName="FillByRankId">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>select * from dbo.tblCertification
where nCertificationId in (select nCertificationId from dbo.tblCertificationRequire
where nRankId =@RankId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="RankId" ColumnName="" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@RankId" Precision="0" Scale="0" Size="4" SourceColumn="" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCrewTableAdapter" GeneratorDataComponentClassName="tblCrewTableAdapter" Name="tblCrew" UserDataComponentName="tblCrewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCrew" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblCrew] WHERE (([nCrewId] = @Original_nCrewId) AND ((@IsNull_iCrewType = 1 AND [iCrewType] IS NULL) OR ([iCrewType] = @Original_iCrewType)) AND ((@IsNull_cFamilyName = 1 AND [cFamilyName] IS NULL) OR ([cFamilyName] = @Original_cFamilyName)) AND ((@IsNull_cMiddleName = 1 AND [cMiddleName] IS NULL) OR ([cMiddleName] = @Original_cMiddleName)) AND ((@IsNull_cFirstName = 1 AND [cFirstName] IS NULL) OR ([cFirstName] = @Original_cFirstName)) AND ((@IsNull_cAlias = 1 AND [cAlias] IS NULL) OR ([cAlias] = @Original_cAlias)) AND ((@IsNull_dDateOfBirth = 1 AND [dDateOfBirth] IS NULL) OR ([dDateOfBirth] = @Original_dDateOfBirth)) AND ((@IsNull_cAddress = 1 AND [cAddress] IS NULL) OR ([cAddress] = @Original_cAddress)) AND ((@IsNull_cPlaceOfBirth = 1 AND [cPlaceOfBirth] IS NULL) OR ([cPlaceOfBirth] = @Original_cPlaceOfBirth)) AND ((@IsNull_cHomeNo = 1 AND [cHomeNo] IS NULL) OR ([cHomeNo] = @Original_cHomeNo)) AND ((@IsNull_cHandNo = 1 AND [cHandNo] IS NULL) OR ([cHandNo] = @Original_cHandNo)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cMaritalStatus = 1 AND [cMaritalStatus] IS NULL) OR ([cMaritalStatus] = @Original_cMaritalStatus)) AND ((@IsNull_cNationality = 1 AND [cNationality] IS NULL) OR ([cNationality] = @Original_cNationality)) AND ((@IsNull_cContactPerson = 1 AND [cContactPerson] IS NULL) OR ([cContactPerson] = @Original_cContactPerson)) AND ((@IsNull_cContactPersonAddress = 1 AND [cContactPersonAddress] IS NULL) OR ([cContactPersonAddress] = @Original_cContactPersonAddress)) AND ((@IsNull_cContactPersonNo = 1 AND [cContactPersonNo] IS NULL) OR ([cContactPersonNo] = @Original_cContactPersonNo)) AND ((@IsNull_cContactRelation = 1 AND [cContactRelation] IS NULL) OR ([cContactRelation] = @Original_cContactRelation)) AND ((@IsNull_cContactEmail = 1 AND [cContactEmail] IS NULL) OR ([cContactEmail] = @Original_cContactEmail)) AND ((@IsNull_fHeight = 1 AND [fHeight] IS NULL) OR ([fHeight] = @Original_fHeight)) AND ((@IsNull_fWeight = 1 AND [fWeight] IS NULL) OR ([fWeight] = @Original_fWeight)) AND ((@IsNull_cBloodGroup = 1 AND [cBloodGroup] IS NULL) OR ([cBloodGroup] = @Original_cBloodGroup)) AND ((@IsNull_fShoeSizeVN = 1 AND [fShoeSizeVN] IS NULL) OR ([fShoeSizeVN] = @Original_fShoeSizeVN)) AND ((@IsNull_fShoeSizeJP = 1 AND [fShoeSizeJP] IS NULL) OR ([fShoeSizeJP] = @Original_fShoeSizeJP)) AND ((@IsNull_fOverallSizeVN = 1 AND [fOverallSizeVN] IS NULL) OR ([fOverallSizeVN] = @Original_fOverallSizeVN)) AND ((@IsNull_cOverallSizeJP = 1 AND [cOverallSizeJP] IS NULL) OR ([cOverallSizeJP] = @Original_cOverallSizeJP)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFamilyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPlaceOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHomeNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHandNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMaritalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactRelation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fWeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cBloodGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fOverallSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cOverallSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblCrew] ([nCrewId], [iCrewType], [bImage], [cFamilyName], [cMiddleName], [cFirstName], [cAlias], [dDateOfBirth], [cAddress], [cPlaceOfBirth], [cHomeNo], [cHandNo], [cEmail], [cMaritalStatus], [cNationality], [cContactPerson], [cContactPersonAddress], [cContactPersonNo], [cContactRelation], [cContactEmail], [fHeight], [fWeight], [cBloodGroup], [fShoeSizeVN], [fShoeSizeJP], [fOverallSizeVN], [cOverallSizeJP]) VALUES (@nCrewId, @iCrewType, @bImage, @cFamilyName, @cMiddleName, @cFirstName, @cAlias, @dDateOfBirth, @cAddress, @cPlaceOfBirth, @cHomeNo, @cHandNo, @cEmail, @cMaritalStatus, @cNationality, @cContactPerson, @cContactPersonAddress, @cContactPersonNo, @cContactRelation, @cContactEmail, @fHeight, @fWeight, @cBloodGroup, @fShoeSizeVN, @fShoeSizeJP, @fOverallSizeVN, @cOverallSizeJP);
SELECT nCrewId, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP FROM tblCrew WHERE (nCrewId = @nCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="bImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nCrewId, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP FROM tblCrew</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblCrew] SET [nCrewId] = @nCrewId, [iCrewType] = @iCrewType, [bImage] = @bImage, [cFamilyName] = @cFamilyName, [cMiddleName] = @cMiddleName, [cFirstName] = @cFirstName, [cAlias] = @cAlias, [dDateOfBirth] = @dDateOfBirth, [cAddress] = @cAddress, [cPlaceOfBirth] = @cPlaceOfBirth, [cHomeNo] = @cHomeNo, [cHandNo] = @cHandNo, [cEmail] = @cEmail, [cMaritalStatus] = @cMaritalStatus, [cNationality] = @cNationality, [cContactPerson] = @cContactPerson, [cContactPersonAddress] = @cContactPersonAddress, [cContactPersonNo] = @cContactPersonNo, [cContactRelation] = @cContactRelation, [cContactEmail] = @cContactEmail, [fHeight] = @fHeight, [fWeight] = @fWeight, [cBloodGroup] = @cBloodGroup, [fShoeSizeVN] = @fShoeSizeVN, [fShoeSizeJP] = @fShoeSizeJP, [fOverallSizeVN] = @fOverallSizeVN, [cOverallSizeJP] = @cOverallSizeJP WHERE (([nCrewId] = @Original_nCrewId) AND ((@IsNull_iCrewType = 1 AND [iCrewType] IS NULL) OR ([iCrewType] = @Original_iCrewType)) AND ((@IsNull_cFamilyName = 1 AND [cFamilyName] IS NULL) OR ([cFamilyName] = @Original_cFamilyName)) AND ((@IsNull_cMiddleName = 1 AND [cMiddleName] IS NULL) OR ([cMiddleName] = @Original_cMiddleName)) AND ((@IsNull_cFirstName = 1 AND [cFirstName] IS NULL) OR ([cFirstName] = @Original_cFirstName)) AND ((@IsNull_cAlias = 1 AND [cAlias] IS NULL) OR ([cAlias] = @Original_cAlias)) AND ((@IsNull_dDateOfBirth = 1 AND [dDateOfBirth] IS NULL) OR ([dDateOfBirth] = @Original_dDateOfBirth)) AND ((@IsNull_cAddress = 1 AND [cAddress] IS NULL) OR ([cAddress] = @Original_cAddress)) AND ((@IsNull_cPlaceOfBirth = 1 AND [cPlaceOfBirth] IS NULL) OR ([cPlaceOfBirth] = @Original_cPlaceOfBirth)) AND ((@IsNull_cHomeNo = 1 AND [cHomeNo] IS NULL) OR ([cHomeNo] = @Original_cHomeNo)) AND ((@IsNull_cHandNo = 1 AND [cHandNo] IS NULL) OR ([cHandNo] = @Original_cHandNo)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cMaritalStatus = 1 AND [cMaritalStatus] IS NULL) OR ([cMaritalStatus] = @Original_cMaritalStatus)) AND ((@IsNull_cNationality = 1 AND [cNationality] IS NULL) OR ([cNationality] = @Original_cNationality)) AND ((@IsNull_cContactPerson = 1 AND [cContactPerson] IS NULL) OR ([cContactPerson] = @Original_cContactPerson)) AND ((@IsNull_cContactPersonAddress = 1 AND [cContactPersonAddress] IS NULL) OR ([cContactPersonAddress] = @Original_cContactPersonAddress)) AND ((@IsNull_cContactPersonNo = 1 AND [cContactPersonNo] IS NULL) OR ([cContactPersonNo] = @Original_cContactPersonNo)) AND ((@IsNull_cContactRelation = 1 AND [cContactRelation] IS NULL) OR ([cContactRelation] = @Original_cContactRelation)) AND ((@IsNull_cContactEmail = 1 AND [cContactEmail] IS NULL) OR ([cContactEmail] = @Original_cContactEmail)) AND ((@IsNull_fHeight = 1 AND [fHeight] IS NULL) OR ([fHeight] = @Original_fHeight)) AND ((@IsNull_fWeight = 1 AND [fWeight] IS NULL) OR ([fWeight] = @Original_fWeight)) AND ((@IsNull_cBloodGroup = 1 AND [cBloodGroup] IS NULL) OR ([cBloodGroup] = @Original_cBloodGroup)) AND ((@IsNull_fShoeSizeVN = 1 AND [fShoeSizeVN] IS NULL) OR ([fShoeSizeVN] = @Original_fShoeSizeVN)) AND ((@IsNull_fShoeSizeJP = 1 AND [fShoeSizeJP] IS NULL) OR ([fShoeSizeJP] = @Original_fShoeSizeJP)) AND ((@IsNull_fOverallSizeVN = 1 AND [fOverallSizeVN] IS NULL) OR ([fOverallSizeVN] = @Original_fOverallSizeVN)) AND ((@IsNull_cOverallSizeJP = 1 AND [cOverallSizeJP] IS NULL) OR ([cOverallSizeJP] = @Original_cOverallSizeJP)));
SELECT nCrewId, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP FROM tblCrew WHERE (nCrewId = @nCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="bImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFamilyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPlaceOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHomeNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHandNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMaritalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactRelation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fWeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cBloodGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fOverallSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cOverallSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="iCrewType" DataSetColumn="iCrewType" />
              <Mapping SourceColumn="bImage" DataSetColumn="bImage" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cAlias" DataSetColumn="cAlias" />
              <Mapping SourceColumn="dDateOfBirth" DataSetColumn="dDateOfBirth" />
              <Mapping SourceColumn="cAddress" DataSetColumn="cAddress" />
              <Mapping SourceColumn="cPlaceOfBirth" DataSetColumn="cPlaceOfBirth" />
              <Mapping SourceColumn="cHomeNo" DataSetColumn="cHomeNo" />
              <Mapping SourceColumn="cHandNo" DataSetColumn="cHandNo" />
              <Mapping SourceColumn="cEmail" DataSetColumn="cEmail" />
              <Mapping SourceColumn="cMaritalStatus" DataSetColumn="cMaritalStatus" />
              <Mapping SourceColumn="cNationality" DataSetColumn="cNationality" />
              <Mapping SourceColumn="cContactPerson" DataSetColumn="cContactPerson" />
              <Mapping SourceColumn="cContactPersonAddress" DataSetColumn="cContactPersonAddress" />
              <Mapping SourceColumn="cContactPersonNo" DataSetColumn="cContactPersonNo" />
              <Mapping SourceColumn="cContactRelation" DataSetColumn="cContactRelation" />
              <Mapping SourceColumn="cContactEmail" DataSetColumn="cContactEmail" />
              <Mapping SourceColumn="fHeight" DataSetColumn="fHeight" />
              <Mapping SourceColumn="fWeight" DataSetColumn="fWeight" />
              <Mapping SourceColumn="cBloodGroup" DataSetColumn="cBloodGroup" />
              <Mapping SourceColumn="fShoeSizeVN" DataSetColumn="fShoeSizeVN" />
              <Mapping SourceColumn="fShoeSizeJP" DataSetColumn="fShoeSizeJP" />
              <Mapping SourceColumn="fOverallSizeVN" DataSetColumn="fOverallSizeVN" />
              <Mapping SourceColumn="cOverallSizeJP" DataSetColumn="cOverallSizeJP" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsCertificate" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsCertificate" msprop:Generator_UserDSName="dsCertificate">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblCertificateCrew" msprop:Generator_TableClassName="tblCertificateCrewDataTable" msprop:Generator_TableVarName="tabletblCertificateCrew" msprop:Generator_TablePropName="tblCertificateCrew" msprop:Generator_RowDeletingName="tblCertificateCrewRowDeleting" msprop:Generator_UserTableName="tblCertificateCrew" msprop:Generator_RowChangingName="tblCertificateCrewRowChanging" msprop:Generator_RowEvHandlerName="tblCertificateCrewRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCertificateCrewRowDeleted" msprop:Generator_RowEvArgName="tblCertificateCrewRowChangeEvent" msprop:Generator_RowChangedName="tblCertificateCrewRowChanged" msprop:Generator_RowClassName="tblCertificateCrewRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nCertificateCrew" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnCertificateCrew" msprop:Generator_ColumnPropNameInRow="nCertificateCrew" msprop:Generator_ColumnPropNameInTable="nCertificateCrewColumn" msprop:Generator_UserColumnName="nCertificateCrew" type="xs:int" />
              <xs:element name="nCertificationId" msprop:Generator_ColumnVarNameInTable="columnnCertificationId" msprop:Generator_ColumnPropNameInRow="nCertificationId" msprop:Generator_ColumnPropNameInTable="nCertificationIdColumn" msprop:Generator_UserColumnName="nCertificationId" type="xs:int" minOccurs="0" />
              <xs:element name="nCrewid" msprop:Generator_ColumnVarNameInTable="columnnCrewid" msprop:Generator_ColumnPropNameInRow="nCrewid" msprop:Generator_ColumnPropNameInTable="nCrewidColumn" msprop:Generator_UserColumnName="nCrewid" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cIssuedBy" msprop:Generator_ColumnVarNameInTable="columncIssuedBy" msprop:Generator_ColumnPropNameInRow="cIssuedBy" msprop:Generator_ColumnPropNameInTable="cIssuedByColumn" msprop:Generator_UserColumnName="cIssuedBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cNumber" msprop:Generator_ColumnVarNameInTable="columncNumber" msprop:Generator_ColumnPropNameInRow="cNumber" msprop:Generator_ColumnPropNameInTable="cNumberColumn" msprop:Generator_UserColumnName="cNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dDateOfIssued" msprop:Generator_ColumnVarNameInTable="columndDateOfIssued" msprop:Generator_ColumnPropNameInRow="dDateOfIssued" msprop:Generator_ColumnPropNameInTable="dDateOfIssuedColumn" msprop:Generator_UserColumnName="dDateOfIssued" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dDateOfExpire" msprop:Generator_ColumnVarNameInTable="columndDateOfExpire" msprop:Generator_ColumnPropNameInRow="dDateOfExpire" msprop:Generator_ColumnPropNameInTable="dDateOfExpireColumn" msprop:Generator_UserColumnName="dDateOfExpire" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nFileName" msprop:Generator_ColumnVarNameInTable="columnnFileName" msprop:Generator_ColumnPropNameInRow="nFileName" msprop:Generator_ColumnPropNameInTable="nFileNameColumn" msprop:Generator_UserColumnName="nFileName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bScanDoc" msprop:Generator_ColumnVarNameInTable="columnbScanDoc" msprop:Generator_ColumnPropNameInRow="bScanDoc" msprop:Generator_ColumnPropNameInTable="bScanDocColumn" msprop:Generator_UserColumnName="bScanDoc" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="cExt" msprop:Generator_ColumnVarNameInTable="columncExt" msprop:Generator_ColumnPropNameInRow="cExt" msprop:Generator_ColumnPropNameInTable="cExtColumn" msprop:Generator_UserColumnName="cExt" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsUnlimited" msprop:Generator_ColumnVarNameInTable="columnIsUnlimited" msprop:Generator_ColumnPropNameInRow="IsUnlimited" msprop:Generator_ColumnPropNameInTable="IsUnlimitedColumn" msprop:Generator_UserColumnName="IsUnlimited" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCertificationRequire" msprop:Generator_TableClassName="tblCertificationRequireDataTable" msprop:Generator_TableVarName="tabletblCertificationRequire" msprop:Generator_TablePropName="tblCertificationRequire" msprop:Generator_RowDeletingName="tblCertificationRequireRowDeleting" msprop:Generator_UserTableName="tblCertificationRequire" msprop:Generator_RowChangingName="tblCertificationRequireRowChanging" msprop:Generator_RowEvHandlerName="tblCertificationRequireRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCertificationRequireRowDeleted" msprop:Generator_RowEvArgName="tblCertificationRequireRowChangeEvent" msprop:Generator_RowChangedName="tblCertificationRequireRowChanged" msprop:Generator_RowClassName="tblCertificationRequireRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nCertifcationRequireId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnCertifcationRequireId" msprop:Generator_ColumnPropNameInRow="nCertifcationRequireId" msprop:Generator_ColumnPropNameInTable="nCertifcationRequireIdColumn" msprop:Generator_UserColumnName="nCertifcationRequireId" type="xs:int" />
              <xs:element name="nCertificationId" msprop:Generator_ColumnVarNameInTable="columnnCertificationId" msprop:Generator_ColumnPropNameInRow="nCertificationId" msprop:Generator_ColumnPropNameInTable="nCertificationIdColumn" msprop:Generator_UserColumnName="nCertificationId" type="xs:int" minOccurs="0" />
              <xs:element name="nRankId" msprop:Generator_ColumnVarNameInTable="columnnRankId" msprop:Generator_ColumnPropNameInRow="nRankId" msprop:Generator_ColumnPropNameInTable="nRankIdColumn" msprop:Generator_UserColumnName="nRankId" type="xs:int" minOccurs="0" />
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCertification" msprop:Generator_TableClassName="tblCertificationDataTable" msprop:Generator_TableVarName="tabletblCertification" msprop:Generator_TablePropName="tblCertification" msprop:Generator_RowDeletingName="tblCertificationRowDeleting" msprop:Generator_UserTableName="tblCertification" msprop:Generator_RowChangingName="tblCertificationRowChanging" msprop:Generator_RowEvHandlerName="tblCertificationRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCertificationRowDeleted" msprop:Generator_RowEvArgName="tblCertificationRowChangeEvent" msprop:Generator_RowChangedName="tblCertificationRowChanged" msprop:Generator_RowClassName="tblCertificationRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nCertificationId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnCertificationId" msprop:Generator_ColumnPropNameInRow="nCertificationId" msprop:Generator_ColumnPropNameInTable="nCertificationIdColumn" msprop:Generator_UserColumnName="nCertificationId" type="xs:int" />
              <xs:element name="cCertificationName" msprop:Generator_ColumnVarNameInTable="columncCertificationName" msprop:Generator_ColumnPropNameInRow="cCertificationName" msprop:Generator_ColumnPropNameInTable="cCertificationNameColumn" msprop:Generator_UserColumnName="cCertificationName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cCertificationDescription" msprop:Generator_ColumnVarNameInTable="columncCertificationDescription" msprop:Generator_ColumnPropNameInRow="cCertificationDescription" msprop:Generator_ColumnPropNameInTable="cCertificationDescriptionColumn" msprop:Generator_UserColumnName="cCertificationDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCrew" msprop:Generator_TableClassName="tblCrewDataTable" msprop:Generator_TableVarName="tabletblCrew" msprop:Generator_TablePropName="tblCrew" msprop:Generator_RowDeletingName="tblCrewRowDeleting" msprop:Generator_UserTableName="tblCrew" msprop:Generator_RowChangingName="tblCrewRowChanging" msprop:Generator_RowEvHandlerName="tblCrewRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCrewRowDeleted" msprop:Generator_RowEvArgName="tblCrewRowChangeEvent" msprop:Generator_RowChangedName="tblCrewRowChanged" msprop:Generator_RowClassName="tblCrewRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iCrewType" msprop:Generator_ColumnVarNameInTable="columniCrewType" msprop:Generator_ColumnPropNameInRow="iCrewType" msprop:Generator_ColumnPropNameInTable="iCrewTypeColumn" msprop:Generator_UserColumnName="iCrewType" type="xs:int" minOccurs="0" />
              <xs:element name="bImage" msprop:Generator_ColumnVarNameInTable="columnbImage" msprop:Generator_ColumnPropNameInRow="bImage" msprop:Generator_ColumnPropNameInTable="bImageColumn" msprop:Generator_UserColumnName="bImage" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cAlias" msprop:Generator_ColumnVarNameInTable="columncAlias" msprop:Generator_ColumnPropNameInRow="cAlias" msprop:Generator_ColumnPropNameInTable="cAliasColumn" msprop:Generator_UserColumnName="cAlias" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dDateOfBirth" msprop:Generator_ColumnVarNameInTable="columndDateOfBirth" msprop:Generator_ColumnPropNameInRow="dDateOfBirth" msprop:Generator_ColumnPropNameInTable="dDateOfBirthColumn" msprop:Generator_UserColumnName="dDateOfBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cAddress" msprop:Generator_ColumnVarNameInTable="columncAddress" msprop:Generator_ColumnPropNameInRow="cAddress" msprop:Generator_ColumnPropNameInTable="cAddressColumn" msprop:Generator_UserColumnName="cAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cPlaceOfBirth" msprop:Generator_ColumnVarNameInTable="columncPlaceOfBirth" msprop:Generator_ColumnPropNameInRow="cPlaceOfBirth" msprop:Generator_ColumnPropNameInTable="cPlaceOfBirthColumn" msprop:Generator_UserColumnName="cPlaceOfBirth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHomeNo" msprop:Generator_ColumnVarNameInTable="columncHomeNo" msprop:Generator_ColumnPropNameInRow="cHomeNo" msprop:Generator_ColumnPropNameInTable="cHomeNoColumn" msprop:Generator_UserColumnName="cHomeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHandNo" msprop:Generator_ColumnVarNameInTable="columncHandNo" msprop:Generator_ColumnPropNameInRow="cHandNo" msprop:Generator_ColumnPropNameInTable="cHandNoColumn" msprop:Generator_UserColumnName="cHandNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cEmail" msprop:Generator_ColumnVarNameInTable="columncEmail" msprop:Generator_ColumnPropNameInRow="cEmail" msprop:Generator_ColumnPropNameInTable="cEmailColumn" msprop:Generator_UserColumnName="cEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMaritalStatus" msprop:Generator_ColumnVarNameInTable="columncMaritalStatus" msprop:Generator_ColumnPropNameInRow="cMaritalStatus" msprop:Generator_ColumnPropNameInTable="cMaritalStatusColumn" msprop:Generator_UserColumnName="cMaritalStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cNationality" msprop:Generator_ColumnVarNameInTable="columncNationality" msprop:Generator_ColumnPropNameInRow="cNationality" msprop:Generator_ColumnPropNameInTable="cNationalityColumn" msprop:Generator_UserColumnName="cNationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPerson" msprop:Generator_ColumnVarNameInTable="columncContactPerson" msprop:Generator_ColumnPropNameInRow="cContactPerson" msprop:Generator_ColumnPropNameInTable="cContactPersonColumn" msprop:Generator_UserColumnName="cContactPerson" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPersonAddress" msprop:Generator_ColumnVarNameInTable="columncContactPersonAddress" msprop:Generator_ColumnPropNameInRow="cContactPersonAddress" msprop:Generator_ColumnPropNameInTable="cContactPersonAddressColumn" msprop:Generator_UserColumnName="cContactPersonAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPersonNo" msprop:Generator_ColumnVarNameInTable="columncContactPersonNo" msprop:Generator_ColumnPropNameInRow="cContactPersonNo" msprop:Generator_ColumnPropNameInTable="cContactPersonNoColumn" msprop:Generator_UserColumnName="cContactPersonNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactRelation" msprop:Generator_ColumnVarNameInTable="columncContactRelation" msprop:Generator_ColumnPropNameInRow="cContactRelation" msprop:Generator_ColumnPropNameInTable="cContactRelationColumn" msprop:Generator_UserColumnName="cContactRelation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactEmail" msprop:Generator_ColumnVarNameInTable="columncContactEmail" msprop:Generator_ColumnPropNameInRow="cContactEmail" msprop:Generator_ColumnPropNameInTable="cContactEmailColumn" msprop:Generator_UserColumnName="cContactEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fHeight" msprop:Generator_ColumnVarNameInTable="columnfHeight" msprop:Generator_ColumnPropNameInRow="fHeight" msprop:Generator_ColumnPropNameInTable="fHeightColumn" msprop:Generator_UserColumnName="fHeight" type="xs:double" minOccurs="0" />
              <xs:element name="fWeight" msprop:Generator_ColumnVarNameInTable="columnfWeight" msprop:Generator_ColumnPropNameInRow="fWeight" msprop:Generator_ColumnPropNameInTable="fWeightColumn" msprop:Generator_UserColumnName="fWeight" type="xs:double" minOccurs="0" />
              <xs:element name="cBloodGroup" msprop:Generator_ColumnVarNameInTable="columncBloodGroup" msprop:Generator_ColumnPropNameInRow="cBloodGroup" msprop:Generator_ColumnPropNameInTable="cBloodGroupColumn" msprop:Generator_UserColumnName="cBloodGroup" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fShoeSizeVN" msprop:Generator_ColumnVarNameInTable="columnfShoeSizeVN" msprop:Generator_ColumnPropNameInRow="fShoeSizeVN" msprop:Generator_ColumnPropNameInTable="fShoeSizeVNColumn" msprop:Generator_UserColumnName="fShoeSizeVN" type="xs:double" minOccurs="0" />
              <xs:element name="fShoeSizeJP" msprop:Generator_ColumnVarNameInTable="columnfShoeSizeJP" msprop:Generator_ColumnPropNameInRow="fShoeSizeJP" msprop:Generator_ColumnPropNameInTable="fShoeSizeJPColumn" msprop:Generator_UserColumnName="fShoeSizeJP" type="xs:double" minOccurs="0" />
              <xs:element name="fOverallSizeVN" msprop:Generator_ColumnVarNameInTable="columnfOverallSizeVN" msprop:Generator_ColumnPropNameInRow="fOverallSizeVN" msprop:Generator_ColumnPropNameInTable="fOverallSizeVNColumn" msprop:Generator_UserColumnName="fOverallSizeVN" type="xs:double" minOccurs="0" />
              <xs:element name="cOverallSizeJP" msprop:Generator_ColumnVarNameInTable="columncOverallSizeJP" msprop:Generator_ColumnPropNameInRow="cOverallSizeJP" msprop:Generator_ColumnPropNameInTable="cOverallSizeJPColumn" msprop:Generator_UserColumnName="cOverallSizeJP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCertificateCrew" />
      <xs:field xpath="mstns:nCertificateCrew" />
    </xs:unique>
    <xs:unique name="tblCertificationRequire_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCertificationRequire" />
      <xs:field xpath="mstns:nCertifcationRequireId" />
    </xs:unique>
    <xs:unique name="tblCertification_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCertification" />
      <xs:field xpath="mstns:nCertificationId" />
    </xs:unique>
    <xs:unique name="tblCrew_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCrew" />
      <xs:field xpath="mstns:nCrewId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblCertificateCrew_tblCertification" msdata:parent="tblCertification" msdata:child="tblCertificateCrew" msdata:parentkey="nCertificationId" msdata:childkey="nCertificationId" msprop:Generator_UserChildTable="tblCertificateCrew" msprop:Generator_ChildPropName="GettblCertificateCrewRows" msprop:Generator_UserParentTable="tblCertification" msprop:Generator_UserRelationName="FK_tblCertificateCrew_tblCertification" msprop:Generator_RelationVarName="relationFK_tblCertificateCrew_tblCertification" msprop:Generator_ParentPropName="tblCertificationRow" />
      <msdata:Relationship name="FK_tblCertificateCrew_tblCrew" msdata:parent="tblCrew" msdata:child="tblCertificateCrew" msdata:parentkey="nCrewId" msdata:childkey="nCrewid" msprop:Generator_UserChildTable="tblCertificateCrew" msprop:Generator_ChildPropName="GettblCertificateCrewRows" msprop:Generator_UserParentTable="tblCrew" msprop:Generator_UserRelationName="FK_tblCertificateCrew_tblCrew" msprop:Generator_RelationVarName="relationFK_tblCertificateCrew_tblCrew" msprop:Generator_ParentPropName="tblCrewRow" />
      <msdata:Relationship name="FK_tblCertificationRequire_tblCertification" msdata:parent="tblCertification" msdata:child="tblCertificationRequire" msdata:parentkey="nCertificationId" msdata:childkey="nCertificationId" msprop:Generator_UserChildTable="tblCertificationRequire" msprop:Generator_ChildPropName="GettblCertificationRequireRows" msprop:Generator_UserParentTable="tblCertification" msprop:Generator_UserRelationName="FK_tblCertificationRequire_tblCertification" msprop:Generator_RelationVarName="relationFK_tblCertificationRequire_tblCertification" msprop:Generator_ParentPropName="tblCertificationRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>